A Cloud-Scale View Of The Star Formation Process In Nearby Galaxies